{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["4 Ob 8-19h Betreuung gerundet","Betreuung exakt berücksichtigt","10 Ob 23-18g TL nach Unterhalti"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":53,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"4 Ob 8-19h Betreuung gerundet","index":0,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Kennwort für entsperren / schützen = gesperrt",null,"Zahlung","Zahlung",null,null,null,"Zahlung","Zahlung"]
["Spalten B-E: BVE bezieht Tlei","Tlei BVE","BVE ==> SVE","BVE <== SVE","Tlei SVE",null,"Tlei BVE","BVE ==> SVE","BVE <== SVE","Tlei SVE"]
["Spalten G-J: SVE bezieht Tlei"]
["Betreuungszeit",0.5,null,null,{"$f":"1-B7","v":0.5},null,{"$f":"BZBVE","v":0.5},null,null,{"$f":"BZSVE","v":0.5}]
["UBGR",4312,null,null,2028,null,{"$f":"UBGRBVE","v":4312},null,null,{"$f":"UBGRSVE","v":2028}]
["Prozentsatz",0.18,null,null,0.18,null,{"$f":"PROZBVE","v":0.18},null,null,{"$f":"PROZSVE","v":0.18}]
["Prozentunterhalt BVE (PU BVE)",{"$f":"B8*B9","v":776.16},"Luxusgrenze?",null,null,null,{"$f":"PUBVE","v":776.16}]
["Prozentunterhalt SVE (PU SVE)",null,null,"Luxusgrenze?",{"$f":"E8*E9","v":365.03999999999996},null,null,null,null,{"$f":"PUSVE","v":365.03999999999996}]
["Anteil am Prozentunterhalt",{"$f":"B10/(B10+E11)","v":0.68012618296529981},null,null,{"$f":"E11/(B10+E11)","v":0.31987381703470036},null,{"$f":"ANTPUBVE","v":0.68012618296529981},null,null,{"$f":"ANTPUSVE","v":0.31987381703470036}]
["reduzierter PU BVE",{"$f":"B10*0.5","v":388.08},null,null,null,null,{"$f":"REDUHBVE","v":388.08}]
["reduzierter PU SVE",null,null,null,{"$f":"E11*0.5","v":182.51999999999998},null,null,null,null,{"$f":"REDUHSVE","v":182.51999999999998}]
["Verrechnung reduzierte Pue",null,{"$f":"B13","v":388.08},{"$f":"E14","v":182.51999999999998},null,null,null,{"$f":"C15","v":388.08},{"$f":"D15","v":182.51999999999998}]
["Familienbonus Plus (FB +) (1)",0,null,null,0,null,{"$f":"FABOBVE","v":0},null,null,{"$f":"FABOSVE","v":0}]
["FB + Ausgleich",null,{"$f":"B16/2","v":0},{"$f":"E16/2","v":0},null,null,null,{"$f":"C17","v":0},{"$f":"D17","v":0}]
["Familienbeihilfe (FBH) (2)",148,null,null,null,null,null,null,null,{"$f":"B18","v":148}]
["Ausgleich FBH",null,{"$f":"B18/2","v":74},null,null,null,null,null,{"$f":"J18/2","v":74}]
["Kinderabsetzbetrag (KAB)",0,null,null,null,null,null,null,null,{"$f":"B20","v":0}]
["Ausgleich KAB",null,{"$f":"B20/2","v":0},null,null,null,null,null,{"$f":"J20/2","v":0}]
["Unterhaltsabsetzbetrag (UAB) (3)",null,null,null,0,null,0]
["Ausgleich UAB",null,null,{"$f":"E22/2","v":0},null,null,null,{"$f":"G22/2","v":0}]
[]
["Summen vor Saldierung",null,{"$f":"SUM(C10:C23)","v":462.08},{"$f":"SUM(D7:D23)","v":182.51999999999998},null,null,null,{"$f":"SUM(H10:H23)","v":388.08},{"$f":"SUM(I7:I23)","v":256.52}]
["RU (Zahlung BVE an SVE)",null,{"$f":"C25-D25","v":279.56},null,null,null,null,{"$f":"H25-I25","v":131.56}]
["RU (Zahlung SVE an BVE)"]
["im Haushalt SVE verbleiben",null,null,null,{"$f":"C26+E16+E22","v":279.56},null,null,null,null,{"$f":"H26+J16+J18+J20","v":279.56}]
["in diese Zellen die Daten eingeben"]
["Inhalt wird berechnet (keine Eingabe)",null,null,"SVE",null,"im Haushalt verbleiben",null,null,null,"SVE"]
["Inhalt wird berechnet (keine Eingabe)",null,null,"FB+",{"$f":"E16","v":0},null,null,null,"FB+",{"$f":"J16","v":0}]
["Ergebnis wird berechnet (keine Eingabe)",null,null,"FBH",{"$f":"E18","v":0},null,null,null,"FBH",{"$f":"J18","v":148}]
[null,null,null,"UAB",{"$f":"E22","v":0},null,null,null,"KAB",{"$f":"J20","v":0}]
["BVE = besser verdienender Elternteil",null,null,"Zahlung BVE",{"$f":"C26","v":279.56},null,null,null,"Zahlung BVE",{"$f":"H26","v":131.56}]
["SVE = Schlechter verdienender Elternteil",null,null,"Summe",{"$f":"SUM(E31:E34)","v":279.56},null,null,null,"Summe",{"$f":"SUM(J31:J34)","v":279.56}]
["FB+ = Familienbonus Plus","Info"]
["FBH = Familienbeihilfe","Info"]
["KAB = Kinderabsetzbetrag","Info"]
["PU = Prozentunterhalt"]
["TFLA = Transferleistungsausgleich"]
["Tlei = Transferleistungen"]
["UAB = Unterhaltsabsetzbetrag","Info"]
[]
["(1) zur Anrechnung des FB+ "]
["beim betreuungsrechtlichen Unterhaltsmodell "]
["gibt es noch keine Judikatur."]
["Eine Eingabe ist nur erforderlich, wenn die "]
["Eltern unterschiedliche Beträge gutgeschrieben"]
["erhalten"]
["(2) wenn mehrere Kinder zu beurteilen sind, wird\ndie Summe der Familienbeihilfe nach Köpfen aufgeteilt"]
["(3) wenn mehrere Kinder zu beurteilen sind, wird\ndie Summe der steigenden Unterhaltgsabsetzbeträge nach Köpfen aufgeteilt"]
["Wenn ein Elternteil nicht genug oder keine Lohnsteuer"]
["oder Einkommenssteuer bezahlt, können "]
["Unterhaltsabsetzbeträge entfallen"]
["weil UABE nicht als Negativsteuer ausbezahlt werden"]

{"sheet":"Betreuung exakt berücksichtigt","index":1,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Kennwort entsperren / schützen = gesperrt",null,"Zahlung","Zahlung",null,null,null,"Zahlung","Zahlung"]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A5","v":"Spalten B-E: BVE bezieht Tlei"},"Tlei BVE","BVE ==> SVE","BVE <== SVE","Tlei SVE",null,"Tlei BVE","BVE ==> SVE","BVE <== SVE","Tlei SVE"]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A6","v":"Spalten G-J: SVE bezieht Tlei"}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A7","v":"Betreuungszeit"},{"$f":"BZBVE","v":0.5},null,null,{"$f":"BZSVE","v":0.5},null,{"$f":"BZBVE","v":0.5},null,null,{"$f":"BZSVE","v":0.5}]
["UBGR",{"$f":"UBGRBVE","v":4312},null,null,{"$f":"UBGRSVE","v":2028},null,{"$f":"UBGRBVE","v":4312},null,null,{"$f":"UBGRSVE","v":2028}]
["Prozentsatz",{"$f":"PROZBVE","v":0.18},null,null,{"$f":"PROZSVE","v":0.18},null,{"$f":"PROZBVE","v":0.18},null,null,{"$f":"PROZSVE","v":0.18}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A10","v":"Prozentunterhalt BVE (PU BVE)"},{"$f":"PUBVE","v":776.16},null,null,null,null,{"$f":"PUBVE","v":776.16}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A11","v":"Prozentunterhalt SVE (PU SVE)"},null,null,null,{"$f":"PUSVE","v":365.03999999999996},null,null,null,null,{"$f":"PUSVE","v":365.03999999999996}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A12","v":"Anteil am Prozentunterhalt"},{"$f":"B7/(B7+E8)","v":0.68012618296529981},null,null,{"$f":"E8/(B7+E8)","v":0.31987381703470036},null,{"$f":"G7/(G7+J8)","v":0.68012618296529981},null,null,{"$f":"J8/(G7+J8)","v":0.31987381703470036}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A13","v":"reduzierter PU BVE"},{"$f":"B7*E4","v":388.08},null,null,null,null,{"$f":"B10","v":388.08}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A14","v":"reduzierter PU SVE"},null,null,null,{"$f":"E8*B4","v":182.51999999999998},null,null,null,null,{"$f":"E11","v":182.51999999999998}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A15","v":"Verrechnung reduzierte Pue"},null,{"$f":"B10","v":388.08},{"$f":"E11","v":182.51999999999998},null,null,null,{"$f":"G10","v":388.08},{"$f":"J11","v":182.51999999999998}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A16","v":"Familienbonus Plus (FB +) (1)"},{"$f":"FABOBVE","v":0},null,null,{"$f":"FABOSVE","v":0},null,{"$f":"FABOBVE","v":0},null,null,{"$f":"FABOSVE","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A17","v":"FB + Ausgleich"},null,{"$f":"B13*E4","v":0},{"$f":"E13*B4","v":0},null,null,null,{"$f":"G13*J4","v":0},{"$f":"J13*G4","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A18","v":"Familienbeihilfe (FBH) (2)"},{"$f":"FBHBVE","v":148},null,null,null,null,null,null,null,{"$f":"FBHSVE","v":148}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A19","v":"Ausgleich FBH"},null,{"$f":"B15*E4","v":74},null,null,null,null,null,{"$f":"J15*G4","v":74}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A20","v":"Kinderabsetzbetrag (KAB)"},{"$f":"KABBVE","v":0},null,null,null,null,null,null,null,{"$f":"KABSVE","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A21","v":"Ausgleich KAB"},null,{"$f":"B17*E4","v":0},null,null,null,null,null,{"$f":"J17*G4","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A22","v":"Unterhaltsabsetzbetrag (UAB) (3)"},null,null,null,{"$f":"UABSVE","v":0},null,{"$f":"UABBVE","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A23","v":"Ausgleich UAB"},null,null,{"$f":"E19*B4","v":0},null,null,null,{"$f":"G19*J4","v":0}]
[]
["Summen vor Saldierung",null,{"$f":"SUM(C7:C20)","v":462.08},{"$f":"SUM(D4:D20)","v":182.51999999999998},null,null,null,{"$f":"SUM(H7:H20)","v":388.08},{"$f":"SUM(I4:I20)","v":256.52}]
["RU (Zahlung BVE an SVE)",null,{"$f":"C22-D22","v":279.56},null,null,null,null,{"$f":"H22-I22","v":131.56}]
["RU (Zahlung SVE an BVE)"]
["im Haushalt SVE verbleiben",null,null,null,{"$f":"E13+E19+C23","v":279.56},null,null,null,null,{"$f":"J13+J15+J17+H23","v":279.56}]
[]
["Inhalt wird berechnet (keine Eingabe)",null,null,"SVE",null,"im Haushalt verbleiben",null,null,null,"SVE"]
["Inhalt wird berechnet (keine Eingabe)",null,null,"FB+",{"$f":"E13","v":0},null,null,null,"FB+",{"$f":"J13","v":0}]
["Ergebnis wird berechnet (keine Eingabe)",null,null,"FBH",{"$f":"E15","v":0},null,null,null,"FBH",{"$f":"J15","v":148}]
[null,null,null,"UAB",{"$f":"E19","v":0},null,null,null,"KAB",{"$f":"J17","v":0}]
["BVE = besser verdienender Elternteil",null,null,"Zahlung BVE",{"$f":"C23","v":279.56},null,null,null,"Zahlung BVE",{"$f":"H23","v":131.56}]
["SVE = Schlechter verdienender Elternteil",null,null,"Summe",{"$f":"SUM(E28:E31)","v":279.56},null,null,null,"Summe",{"$f":"SUM(J28:J31)","v":279.56}]
["FB+ = Familienbonus Plus","Info"]
["FBH = Familienbeihilfe","Info"]
["KAB = Kinderabsetzbetrag","Info"]
["PU = Prozentunterhalt"]
["TFLA = Transferleistungsausgleich"]
["Tlei = Transferleistungen"]
["UAB = Unterhaltsabsetzbetrag","Info"]

{"sheet":"10 Ob 23-18g TL nach Unterhalti","index":2,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Kennwort entsperren / schützen = gesperrt",null,"Zahlung","Zahlung",null,null,null,"Zahlung","Zahlung"]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A5","v":"Spalten B-E: BVE bezieht Tlei"},"Tlei BVE","BVE ==> SVE","BVE <== SVE","Tlei SVE",null,"Tlei BVE","BVE ==> SVE","BVE <== SVE","Tlei SVE"]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A6","v":"Spalten G-J: SVE bezieht Tlei"}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A7","v":"Betreuungszeit"},{"$f":"'4 Ob 8-19h Betreuung gerundet'!B7","v":0.5},null,null,{"$f":"BZSVE","v":0.5},null,{"$f":"'4 Ob 8-19h Betreuung gerundet'!B7","v":0.5},null,null,{"$f":"E4","v":0.5}]
["UBGR",{"$f":"UBGRBVE","v":4312},null,null,{"$f":"UBGRSVE","v":2028},null,{"$f":"UBGRBVE","v":4312},null,null,{"$f":"UBGRSVE","v":2028}]
["Prozentsatz",{"$f":"PROZBVE","v":0.18},null,null,{"$f":"PROZSVE","v":0.18},null,{"$f":"PROZBVE","v":0.18},null,null,{"$f":"PROZSVE","v":0.18}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A10","v":"Prozentunterhalt BVE (PU BVE)"},{"$f":"PUBVE","v":776.16},null,null,null,null,{"$f":"'4 Ob 8-19h Betreuung gerundet'!B10","v":776.16}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A11","v":"Prozentunterhalt SVE (PU SVE)"},null,null,null,{"$f":"PUSVE","v":365.03999999999996},null,null,null,null,{"$f":"'4 Ob 8-19h Betreuung gerundet'!J11","v":365.03999999999996}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A12","v":"Anteil am Prozentunterhalt"},{"$f":"B7/(B7+E8)","v":0.68012618296529981},null,null,{"$f":"E8/(B7+E8)","v":0.31987381703470036},null,{"$f":"B9","v":0.68012618296529981},null,null,{"$f":"E9","v":0.31987381703470036}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A13","v":"reduzierter PU BVE"},{"$f":"B7*E4","v":388.08},null,null,null,null,{"$f":"B10","v":388.08}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A14","v":"reduzierter PU SVE"},null,null,null,{"$f":"E8*B4","v":182.51999999999998},null,null,null,null,{"$f":"J8*G4","v":182.51999999999998}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A15","v":"Verrechnung reduzierte Pue"},null,{"$f":"B7*E4","v":388.08},{"$f":"E8*B4","v":182.51999999999998},null,null,null,{"$f":"C12","v":388.08},{"$f":"D12","v":182.51999999999998}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A16","v":"Familienbonus Plus (FB +) (1)"},{"$f":"FABOBVE","v":0},null,null,{"$f":"FABOSVE","v":0},null,{"$f":"FABOBVE","v":0},null,null,{"$f":"FABOSVE","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A17","v":"FB + Ausgleich"},null,{"$f":"B13*E9","v":0},{"$f":"E13*B9","v":0},null,null,null,{"$f":"B13*E9","v":0},{"$f":"E13*B9","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A18","v":"Familienbeihilfe (FBH) (2)"},{"$f":"FBHBVE","v":148},null,null,null,null,null,null,null,{"$f":"FBHSVE","v":148}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A19","v":"Ausgleich FBH"},null,{"$f":"B15*E9","v":47.341324921135651},null,null,null,null,null,{"$f":"J15*G9","v":100.65867507886438}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A20","v":"Kinderabsetzbetrag (KAB)"},{"$f":"KABBVE","v":0},null,null,null,null,null,null,null,{"$f":"'4 Ob 8-19h Betreuung gerundet'!J20","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A21","v":"Ausgleich KAB"},null,{"$f":"B17*E9","v":0},null,null,null,null,null,{"$f":"J17*G9","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A22","v":"Unterhaltsabsetzbetrag (UAB) (3)"},null,null,null,{"$f":"UABSVE","v":0},null,{"$f":"UABBVE","v":0}]
[{"$f":"'4 Ob 8-19h Betreuung gerundet'!A23","v":"Ausgleich UAB"},null,null,{"$f":"E19*B9","v":0},null,null,null,{"$f":"G19*J9","v":0}]
[]
["Summen vor Saldierung",null,{"$f":"SUM(C7:C20)","v":435.42132492113564},{"$f":"SUM(D4:D20)","v":182.51999999999998},null,null,null,{"$f":"SUM(H7:H20)","v":388.08},{"$f":"SUM(I4:I20)","v":283.17867507886433}]
["RU (Zahlung BVE an SVE)",null,{"$f":"C22-D22","v":252.90132492113565},null,null,null,null,{"$f":"H22-I22","v":104.90132492113565}]
["RU (Zahlung SVE an BVE)"]
["im Haushalt SVE verbleiben",null,null,null,{"$f":"E13+E19+C23","v":252.90132492113565},null,null,null,null,{"$f":"J13+J15+J17+H23","v":252.90132492113565}]
[]
["Inhalt wird berechnet (keine Eingabe)",null,null,"SVE",null,"im Haushalt verbleiben",null,null,null,"SVE"]
["Inhalt wird berechnet (keine Eingabe)",null,null,"FB+",{"$f":"E13","v":0},null,null,null,"FB+",{"$f":"J13","v":0}]
["Ergebnis wird berechnet (keine Eingabe)",null,null,"FBH",{"$f":"E15","v":0},null,null,null,"FBH",{"$f":"J15","v":148}]
[null,null,null,"UAB",{"$f":"E19","v":0},null,null,null,"KAB",{"$f":"J17","v":0}]
["BVE = besser verdienender Elternteil",null,null,"Zahlung BVE",{"$f":"C23","v":252.90132492113565},null,null,null,"Zahlung BVE",{"$f":"H23","v":104.90132492113565}]
["SVE = Schlechter verdienender Elternteil",null,null,"Summe",{"$f":"SUM(E28:E31)","v":252.90132492113565},null,null,null,"Summe",{"$f":"SUM(J28:J31)","v":252.90132492113565}]
["FB+ = Familienbonus Plus","Info"]
["FBH = Familienbeihilfe","Info"]
["KAB = Kinderabsetzbetrag","Info"]
["PU = Prozentunterhalt"]
["TFLA = Transferleistungsausgleich"]
["Tlei = Transferleistungen"]
["UAB = Unterhaltsabsetzbetrag","Info"]